import sqlite3

conn = sqlite3.connect("AnimateDB.db")
c = conn.cursor()

# c.execute("INSERT INTO ANIMATE (AID, NAME, ALL_SEASON, B_INFO, RATE, ACTOR, KEY_WORD) \
#         VALUES (5, '缘之空', 1, '简介', 4.9, '{actor:[\"dd\", \"ddd\"]}', '{key_word:[\"dd\", \"ddd\"]}')")
# c.execute("INSERT INTO ANIMATE (AID, NAME, ALL_SEASON, B_INFO, RATE, ACTOR, KEY_WORD) \
#         VALUES (3, '缘之空2', 1, '简介', 4.9, '{actor:[\"dd\", \"ddd\"]}', '{key_word:[\"dd\", \"ddd\"]}')")
# c.execute("INSERT INTO ANIMATE (AID, NAME, ALL_SEASON, B_INFO, RATE, ACTOR, KEY_WORD) \
#         VALUES (4, '缘之空3', 1, '简介', 4.9, '{actor:[\"dd\", \"ddd\"]}', '{key_word:[\"dd\", \"ddd\"]}')")

s = c.execute("SELECT AID, NAME from ANIMATE where RATE=4.9 OR NAME='缘之空';")

n = 1;
print('AID' + '\t' * n + '|NAME')
print('-------------------')
for item in s:
        print(item[0],end='\t|')
        print(item[1])

conn.commit()
conn.close()